//
//  DBHelper.h
//  TestARC
//
//  Created by wuxiaoquan on 12-9-26.
//
//

#import <UIKit/UIKit.h>
#import <sqlite3.h>
#import "FMDB/FMDatabase.h"

@interface DBHelper : NSObject
{
    FMDatabase *database;
}

@property NSString *databaseFilePath;

-(NSString *)getDBFilePath;

-(BOOL)open;

-(BOOL)close;

- (FMResultSet *)quaryCommonDrug;
- (FMResultSet *)quaryCommonDisease;

- (FMResultSet *)searchDrugSeggestion:(NSString *)queryText;
- (FMResultSet *)searchDiseaseSeggestion:(NSString *)queryText;

- (FMResultSet *)queryDrugsLike:(NSString *)queryId;
- (FMResultSet *)searchDrugWithBrandName:(NSString *)queryText;

- (FMResultSet *)searchBothSeggestion:(NSString *)queryText;

@end
